2025-03-05 21:51:26,046 [ 678582 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2025-03-05 21:51:26,046 [ 678582 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2025-03-05 21:51:26,046 [ 678582 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2025-03-05 21:51:26,046 [ 678582 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_wku0qq --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 'test_storage_rabbitmq/test.py::test_rabbitmq_select[0]' 'test_storage_rabbitmq/test.py::test_rabbitmq_select[1]' test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats test_storage_url_http_headers/test.py::test_storage_url_http_headers test_storage_url_http_headers/test.py::test_storage_url_redirected_headers test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_logs/test_system_logs.py::test_system_logs_order_by_expr test_system_logs/test_system_logs.py::test_system_logs_settings_expr 'test_system_merges/test.py::test_merge_simple[]' 'test_system_merges/test.py::test_merge_simple[replicated]' 'test_system_merges/test.py::test_mutation_simple[]' 'test_system_merges/test.py::test_mutation_simple[replicated]' test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_truncate_database/test_replicated.py::test_truncate_database_replicated test_undrop_query/test.py::test_undrop_drop_and_undrop_loop test_user_defined_object_persistence/test.py::test_persistence test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.2.0, repeat-0.9.3, reportlog-0.4.0, order-1.0.1, random-0.2, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [35 items] scheduling tests via LoadFileScheduling test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_truncate_database/test_replicated.py::test_truncate_database_replicated test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_system_queries/test.py::test_DROP_DNS_CACHE test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_merges/test.py::test_merge_simple[] test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_storage_url_http_headers/test.py::test_storage_url_http_headers test_user_defined_object_persistence/test.py::test_persistence test_undrop_query/test.py::test_undrop_drop_and_undrop_loop [gw3] [ 2%] PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config [gw3] [ 5%] PASSED test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config [gw3] [ 8%] PASSED test_user_grants_from_config/test.py::test_user_grants_from_config [gw5] [ 11%] PASSED test_storage_url_http_headers/test.py::test_storage_url_http_headers test_storage_url_http_headers/test.py::test_storage_url_redirected_headers [gw5] [ 14%] PASSED test_storage_url_http_headers/test.py::test_storage_url_redirected_headers [gw2] [ 17%] PASSED test_system_queries/test.py::test_DROP_DNS_CACHE test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS [gw4] [ 20%] PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_logs/test_system_logs.py::test_system_logs_order_by_expr [gw2] [ 22%] PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY [gw4] [ 25%] PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr test_system_logs/test_system_logs.py::test_system_logs_settings_expr [gw6] [ 28%] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data [gw4] [ 31%] PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr [gw2] [ 34%] PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY test_system_queries/test.py::test_system_flush_logs test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access [gw2] [ 37%] PASSED test_system_queries/test.py::test_system_flush_logs [gw9] [ 40%] PASSED test_user_defined_object_persistence/test.py::test_persistence [gw5] [ 42%] PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access [gw1] [ 45%] PASSED test_system_merges/test.py::test_merge_simple[] test_system_merges/test.py::test_merge_simple[replicated] [gw7] [ 48%] PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated [gw8] [ 51%] PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop [gw1] [ 54%] PASSED test_system_merges/test.py::test_merge_simple[replicated] test_system_merges/test.py::test_mutation_simple[] [gw1] [ 57%] PASSED test_system_merges/test.py::test_mutation_simple[] test_system_merges/test.py::test_mutation_simple[replicated] [gw1] [ 60%] PASSED test_system_merges/test.py::test_mutation_simple[replicated] [gw0] [ 62%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages [gw0] [ 65%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 [gw0] [ 68%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 [gw0] [ 71%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 test_storage_rabbitmq/test.py::test_rabbitmq_select[0] [gw0] [ 74%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] test_storage_rabbitmq/test.py::test_rabbitmq_select[1] [gw0] [ 77%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] test_storage_rabbitmq/test.py::test_rabbitmq_select_empty [gw0] [ 80%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish [gw0] [ 82%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange [gw0] [ 85%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter [gw0] [ 88%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter test_storage_rabbitmq/test.py::test_rabbitmq_vhost [gw0] [ 91%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns [gw0] [ 94%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view [gw0] [ 97%] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view test_storage_rabbitmq/test.py::test_row_based_formats [gw0] [100%] PASSED test_storage_rabbitmq/test.py::test_row_based_formats ============================== slowest durations =============================== 363.08s call test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 58.99s call test_storage_rabbitmq/test.py::test_row_based_formats 54.34s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 44.27s call test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 36.66s call test_system_merges/test.py::test_mutation_simple[replicated] 36.32s call test_system_merges/test.py::test_mutation_simple[] 30.47s setup test_truncate_database/test_replicated.py::test_truncate_database_replicated 29.58s call test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 27.45s setup test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 21.87s call test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 19.63s setup test_system_merges/test.py::test_merge_simple[] 15.60s call test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 14.18s setup test_system_logs/test_system_logs.py::test_system_logs_engine_expr 13.48s setup test_system_queries/test.py::test_DROP_DNS_CACHE 13.43s setup test_storage_url_http_headers/test.py::test_storage_url_http_headers 13.32s setup test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 13.25s setup test_user_defined_object_persistence/test.py::test_persistence 13.09s setup test_user_grants_from_config/test.py::test_allow_read_from_system_tables 12.95s setup test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 9.93s call test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 9.79s call test_system_merges/test.py::test_merge_simple[replicated] 9.50s call test_system_merges/test.py::test_merge_simple[] 9.36s teardown test_storage_rabbitmq/test.py::test_row_based_formats 8.40s call test_user_defined_object_persistence/test.py::test_persistence 5.75s call test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 5.73s call test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 5.22s setup test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 4.67s teardown test_user_grants_from_config/test.py::test_user_grants_from_config 4.64s teardown test_truncate_database/test_replicated.py::test_truncate_database_replicated 4.54s teardown test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 4.24s teardown test_system_merges/test.py::test_mutation_simple[replicated] 4.05s teardown test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 3.91s teardown test_system_queries/test.py::test_system_flush_logs 3.56s teardown test_undrop_query/test.py::test_undrop_drop_and_undrop_loop 3.54s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 3.54s call test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 3.54s call test_system_queries/test.py::test_system_flush_logs 3.47s teardown test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 2.61s teardown test_system_logs/test_system_logs.py::test_system_logs_settings_expr 2.46s call test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 2.12s call test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 2.05s teardown test_user_defined_object_persistence/test.py::test_persistence 1.41s call test_storage_rabbitmq/test.py::test_rabbitmq_vhost 1.33s call test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.93s call test_system_queries/test.py::test_DROP_DNS_CACHE 0.82s teardown test_storage_rabbitmq/test.py::test_rabbitmq_random_detach 0.82s call test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access 0.75s call test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.46s call test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 0.43s call test_truncate_database/test_replicated.py::test_truncate_database_replicated 0.34s call test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 0.31s call test_system_logs/test_system_logs.py::test_system_logs_settings_expr 0.28s call test_system_logs/test_system_logs.py::test_system_logs_engine_expr 0.19s call test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.18s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.18s teardown test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.13s teardown test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.13s call test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.13s call test_user_grants_from_config/test.py::test_user_grants_from_config 0.12s call test_storage_url_http_headers/test.py::test_storage_url_http_headers 0.12s call test_user_grants_from_config/test.py::test_role_grants_from_config 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.10s teardown test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.07s teardown test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.00s setup test_storage_rabbitmq/test.py::test_row_based_formats 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[0] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select[1] 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_select_empty 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter 0.00s setup test_storage_rabbitmq/test.py::test_rabbitmq_vhost 0.00s setup test_system_merges/test.py::test_mutation_simple[] 0.00s teardown test_system_merges/test.py::test_mutation_simple[] 0.00s teardown test_system_merges/test.py::test_merge_simple[] 0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_engine_expr 0.00s setup test_storage_url_http_headers/test.py::test_storage_url_redirected_headers 0.00s setup test_system_merges/test.py::test_mutation_simple[replicated] 0.00s setup test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s setup test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 0.00s setup test_system_merges/test.py::test_merge_simple[replicated] 0.00s teardown test_system_queries/test.py::test_DROP_DNS_CACHE 0.00s teardown test_system_merges/test.py::test_merge_simple[replicated] 0.00s setup test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s setup test_system_queries/test.py::test_system_flush_logs 0.00s teardown test_storage_url_http_headers/test.py::test_storage_url_http_headers 0.00s teardown test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY 0.00s setup test_system_logs/test_system_logs.py::test_system_logs_settings_expr 0.00s teardown test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.00s setup test_user_grants_from_config/test.py::test_role_grants_from_config 0.00s setup test_user_grants_from_config/test.py::test_user_grants_from_config 0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 0.00s teardown test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS 0.00s teardown test_user_grants_from_config/test.py::test_role_grants_from_config =========================== short test summary info ============================ PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables PASSED test_user_grants_from_config/test.py::test_role_grants_from_config PASSED test_user_grants_from_config/test.py::test_user_grants_from_config PASSED test_storage_url_http_headers/test.py::test_storage_url_http_headers PASSED test_storage_url_http_headers/test.py::test_storage_url_redirected_headers PASSED test_system_queries/test.py::test_DROP_DNS_CACHE PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr PASSED test_system_queries/test.py::test_RELOAD_CONFIG_AND_MACROS PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr PASSED test_system_queries/test.py::test_SYSTEM_RELOAD_DICTIONARY PASSED test_system_queries/test.py::test_system_flush_logs PASSED test_user_defined_object_persistence/test.py::test_persistence PASSED test_user_zero_database_access/test_user_zero_database_access.py::test_user_zero_database_access PASSED test_system_merges/test.py::test_merge_simple[] PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated PASSED test_undrop_query/test.py::test_undrop_drop_and_undrop_loop PASSED test_system_merges/test.py::test_merge_simple[replicated] PASSED test_system_merges/test.py::test_mutation_simple[] PASSED test_system_merges/test.py::test_mutation_simple[replicated] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_random_detach PASSED test_storage_rabbitmq/test.py::test_rabbitmq_reject_broken_messages PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_1 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_restore_failed_connection_without_losses_2 PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[0] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select[1] PASSED test_storage_rabbitmq/test.py::test_rabbitmq_select_empty PASSED test_storage_rabbitmq/test.py::test_rabbitmq_sharding_between_queues_publish PASSED test_storage_rabbitmq/test.py::test_rabbitmq_topic_exchange PASSED test_storage_rabbitmq/test.py::test_rabbitmq_tsv_with_delimiter PASSED test_storage_rabbitmq/test.py::test_rabbitmq_vhost PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns PASSED test_storage_rabbitmq/test.py::test_rabbitmq_virtual_columns_with_materialized_view PASSED test_storage_rabbitmq/test.py::test_row_based_formats ======================== 35 passed in 644.22s (0:10:44) ========================